package com.bear.cmcc.NetTestHTTP.constant;

/**
 * 
 * @author guanyh
 * nettest数据库表
 */
public interface NetTestDBConstant {
	String DBNAME = "testinfo.db";
    int DBVERSION = 5;
    String TABLES_TESTROUNDINFO_NAME = "testroundinfos";//一轮测试信息表
    String TABLES_TESTTIMEINFO_NAME = "testtimesinfos";//一轮中单次测试信息表
	String TABLES_TESTCELLINFO_NAME = "testcellinfos";//一次中单个小区信息表
	String TABLES_CONNECTINFO_NAME = "connectinfos";//单个小区中连接率掉线率信息表
	String EXPORT_DATA_FILE_NAME = "com.bear.cmcc.NetTestHTTP.exportData";
	String EXPORT_DATA_PATH = "";
	
	String TABLES_TESTTIMEINFO_NAME_UP = "uptesttimesinfos";//一轮中单次测试信息表(上行测试)
	/*
	 * 一轮测试表结构
	 */
	interface TestRoundFiledName {
		static String pid = "pid";
		static String startTime = "startTime";//测试开始时间
		static String endTime = "endTime";//测试结束时间
		static String averageSpeed = "averageSpeed";//一轮测试平均速度
		static String up_averageSpeed = "up_averageSpeed";//一轮测试平均速度 upload
		static String maxSpeed = "maxSpeed";//一轮测试最大速度
		static String minSpeed = "minSpeed";//一轮测试最小速度
		static String testTimes = "testTimes";//一轮包含几次测试
		static String isDelete = "isDelete";//是否删除标识，0为正常，1为删除
		static String downServer = "downServer";//一轮测试下载的服务器名
		static String consumeTime = "consumeTime";//一轮测试时间间隔
		
	}
	/*
	 * 一次测试表结构
	 */
	interface TestTimesFiledName {
		static String pid = "pid";
		static String number = "number";
		static String downloadTime = "downloadTime";//一次测试下载时长
		static String fileSize = "fileSize";//一次测试下载文件大小
		static String averageSpeed = "averageSpeed";//一次测试平均速度
		static String maxSpeed = "maxSpeed";//一次测试最大速度
		static String minSpeed = "minSpeed";//一次测试最小速度
		static String downServer = "downServer";//一次测试下载的服务器名
		static String waveShakeStrong = "waveShakeStrong";//一次测试波形抖动强度
		static String roundID = "roundID";//关联一轮测试的pid
		static String replayCode = "replayCode";//ftp返回码
		static String errorReason = "errorReason";//下载失败原因
		static String isDelete = "isDelete";//是否删除标识，0为正常，1为删除
		static String netType = "netType";//网络类型
	}
	/*
	 * 小区信息表结构
	 */
	interface CellInfoFiledName {
		static String pid = "pid";
		static String averageSpeed = "averageSpeed";//某个小区中测试平均速度
		static String maxSpeed = "maxSpeed";//某个小区中测试最大速度
		static String minSpeed = "minSpeed";//某个小区中测试最小速度
		static String lac = "lac";//某个小区lac
		static String ci = "ci";//某个小区ci
		static String cellName = "cellName";//小区中文名
		static String maxNetStrong = "maxNetStrong";//某个小区中最大信号强度
		static String minNetStrong = "minNetStrong";//某个小区中最小信号强度
		static String timesID = "timesID";//关联一次测试的pid
		static String isDelete = "isDelete";//是否删除标识，0为正常，1为删除
	}
	/*
	 * 掉线率接通率表结构
	 */
	interface ConnectFiledName {
		static String pid = "pid";
		static String connectPercent = "connectPercent";//接通率，0为成功连接，1为连接失败
		static String dropPercent = "dropPercent";//掉线率，0为掉线，1为不掉线
		/*
		 * 使用lac和ci来关联cellinfo表，表示掉线率和接通率是针对某一个小区而言的
		 */
		static String lac = "lac";//某个小区lac
		static String ci = "ci";//某个小区ci
		static String isDelete = "isDelete";//是否删除标识，0为正常，1为删除

	}
}
